---
title: "SQL-DCBS-01: Provider DCBS cost charges"
summary: Retrieve DCBS cost-charge factors for a provider location
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-08-21
library: SAIF.Business.View.Provider
reference_type: embedded
---

# SQL-DCBS-01 Provider DCBS cost charges

Retrieves the DCBS cost-charge factor history for a given provider location, including
effective and expiration dates, so the caller can determine the applicable rate for a
date-window calculation.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-DCBS-01 |
| **Operation type** | Read |
| **Execution method** | Inline SQL (StringBuilder-assembled) via `SqlHelper.ResultSetQuery` |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | N/A (Application layer) |
| **Criteria property** | N/A |
| **Lifecycle method** | N/A |
| **Application class** | `clsDCBSCostChargeList` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:ProviderLocationID` | Input | Decimal | N/A | Provider location surrogate key |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [PROVIDER_DCBS_COST_CHARGE](../database-tables.md#provider_dcbs_cost_charge) | SELECT | `PROVIDER_LOCATION_SEQ_NUM`, `EFF_DATE`, `EXP_DATE`, `COST_CHARGE_FACTOR` |

## Sample SQL

```sql
-- Provider DCBS cost charges
SELECT
  PROVIDER_LOCATION_SEQ_NUM AS ProviderLocationID,
  EFF_DATE                  AS EffectiveDate,
  EXP_DATE                  AS ExpirationDate,
  COST_CHARGE_FACTOR        AS CostChargeFactor
FROM PROVIDER_DCBS_COST_CHARGE
WHERE PROVIDER_LOCATION_SEQ_NUM = :ProviderLocationID
```

## Operations and processes
- [Load DCBS cost charge factors](../operations/load-dcbs-cost-charge-factors.md)

## Business rules
- [BR-DATE-001: Date-window effectiveness](../business-rules.md#br-date-001-dated-records-are-in-effect-within-their-date-window)

## Sources
- SAIF.Business.View.Provider/clsDCBSCostCharge.vb